CREATE TABLE "MODEL_CAT" 
   (	"PROD_L1" VARCHAR2(5 BYTE), 
	"MODEL" VARCHAR2(25 BYTE), 
	"CREATE_DATE" DATE DEFAULT sysdate, 
	"SUFFIX" VARCHAR2(20 BYTE), 
	"MP_MODEL" VARCHAR2(25 BYTE), 
	"MP_SUFFIX" VARCHAR2(20 BYTE), 
	"ACTIVE_CODE" VARCHAR2(1 BYTE), 
	"SALE_FLAG" VARCHAR2(1 BYTE), 
	"PROD_L2" VARCHAR2(4 BYTE), 
	"PROD_L3" VARCHAR2(8 BYTE), 
	"PROD_L4" VARCHAR2(10 BYTE), 
	"TENTATIVE_FLAG" VARCHAR2(1 BYTE), 
	"MODEL_SPEC" VARCHAR2(200 BYTE), 
	"PUR_TYPE" VARCHAR2(1 BYTE), 
	"ENABLE_FLAG" VARCHAR2(1 BYTE), 
	"LAST_UPDATE_DATE" DATE, 
	"UNIT" VARCHAR2(1 BYTE), 
	"AU_CODE" VARCHAR2(10 BYTE), 
	"AF_CODE" VARCHAR2(4 BYTE), 
	"EOM" VARCHAR2(2 BYTE), 
	"PROD_TYPE" VARCHAR2(5 BYTE), 
	"MKT" VARCHAR2(1 BYTE), 
	"IF_DATE" DATE DEFAULT sysdate, 
	"SO_TRANSFER_FLAG" VARCHAR2(1 BYTE) DEFAULT 'N', 
	"SO_TRANSFER_DATE" DATE
   ) ;

   CREATE UNIQUE INDEX "MODEL_CAT_PR_KEY" ON "MODEL_CAT" ("MODEL") ;

   ALTER TABLE "MODEL_CAT" ADD CONSTRAINT "MODEL_CAT_PR_KEY" PRIMARY KEY ("MODEL") ENABLE;
   ALTER TABLE "MODEL_CAT" MODIFY ("MODEL" NOT NULL ENABLE);
  --ALTER TABLE "MODEL_CAT" ADD CONSTRAINT "MODEL_CAT_PR_KEY" UNIQUE ("MODEL") DISABLE;



  REM INSERTING into MODEL_CAT
SET DEFINE OFF;
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AV','HT805DM-F2',to_date('07-JAN-10','DD-MON-RR'),'BVNMLLK','HT805DM-F2','BVNMLLK','0','Y','AVAH','AVAHPH','AVAHPHOF','Y','DVD-P HTS','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','PNZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AV','HT805PM-F2',to_date('06-NOV-09','DD-MON-RR'),'BVNMLLK','HT805PM-F2','BVNMLLK','5','Y','AVAH','AVAHPH','AVAHPHOF','N','DVD-P HTS','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','PNZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AV','HT805VM-F2',to_date('23-FEB-10','DD-MON-RR'),'BVNMLLK','HT805VM-F2','BVNMLLK','0','Y','AVAH','AVAHPH','AVAHPHOF','N','DVD-P HTS','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','PNZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AV','HT806PM',to_date('08-OCT-10','DD-MON-RR'),'BVNMLLK','HT806PM','BVNMLLK','5','S','AVAH','AVAHPH','AVAHPHOF','N','DVD-P HTS, HT806, HalfTallboy, 2+2, FM','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','PNZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AV','HT806PM-F2',to_date('25-FEB-11','DD-MON-RR'),'BVNMLLK','HT806PM','BVNMLLK','0','N','AVAH','AVAHPH','AVAHPHOF','N','DVD-P HTS, 850W, HALF TALL, 2+2','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','PNZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AV','HT806PM-F0',to_date('08-OCT-10','DD-MON-RR'),'BVNMLLK','HT806PM','BVNMLLK','0','N','AVAH','AVAHPH','AVAHPHOF','N','DVD-P HTS, HT806, HalfTallboy, 2+2, FM','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','PNZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AV','HT902TB-A2',to_date('17-JAN-07','DD-MON-RR'),'AA2VLLA','HT902TB-A2','AA2VLLA','5','Y','AVAH','AVAHPH','AVAHPHOF','N','RECEIVER HTS DVD','G','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','PNZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AV','HT903TA',to_date('22-DEC-07','DD-MON-RR'),'BVNMLL','HT903TA','BVNMLL','5','Y','AVAH','AVAHPH','AVAHPHOF','N','DVD-P HTS','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','PNZ','EASV','EA','S','2',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AV','HT904TA-A0P',to_date('20-FEB-09','DD-MON-RR'),'BVNMLLK','HT904TA-A0P','BVNMLLK','5','Y','AVAH','AVAHPH','AVAHPHOF','N','DVD-P 1Disc','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','PNZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AV','HT904TA-AK',to_date('23-SEP-09','DD-MON-RR'),'BVNMLLK','HT904TA-AK','BVNMLLK','5','Y','AVAH','AVAHPH','AVAHPHOF','N','DVD-P HTS','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','PNZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AV','HT904TA-AKP',to_date('20-AUG-09','DD-MON-RR'),'BVNMLLK','HT904TA-AKP','BVNMLLK','0','Y','AVAH','AVAHPH','AVAHPHOF','Y','DVD-P HTS','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','PNZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AV','HT905TA-F2',to_date('29-JAN-10','DD-MON-RR'),'BVNMLLK','HT905TA-F2','BVNMLLK','0','Y','AVAH','AVAHPH','AVAHPHOF','N','DVD-P HTS','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','PNZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AV','HT906TA',to_date('08-OCT-10','DD-MON-RR'),'BVNMLLK','HT906TA','BVNMLLK','5','S','AVAH','AVAHPH','AVAHPHOF','N','DVD-P HTS, HB906, TAllboy, FM','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','PNZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AV','HT906TA-F2',to_date('26-FEB-11','DD-MON-RR'),'BVNMLLK','HT906TA','BVNMLLK','0','N','AVAH','AVAHPH','AVAHPHOF','N','DVD-P HTS, 1100W, 5.1ch','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','PNZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AV','HT906TA-F0',to_date('08-OCT-10','DD-MON-RR'),'BVNMLLK','HT906TA','BVNMLLK','0','N','AVAH','AVAHPH','AVAHPHOF','N','DVD-P HTS, HB906, TAllboy, FM','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','PNZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AV','HT953TV-AP',to_date('03-MAR-08','DD-MON-RR'),'BVNMLLK','HT953TV-AP','BVNMLLK','5','Y','AVAH','AVAHPH','AVAHPHOF','N','DVD-P HTS','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','PNZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AV','HT964TZ-AMP',to_date('16-FEB-09','DD-MON-RR'),'BVNMLLK','HT964TZ-AMP','BVNMLLK','5','Y','AVAH','AVAHPH','AVAHPHOF','N','DVD-P HTS','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','PNZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','HTNC186HLA1',to_date('11-JUN-08','DD-MON-RR'),'ANWAEVN','HTNC186HLA1','ANWAEVN','0','Y','ACFS','ACFSCC','ACFSCCCV','N','CEILING & FLOOR_INDOOR','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','DMZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','HTNC246HLA1',to_date('11-JUN-08','DD-MON-RR'),'ANWAEVN','HTNC246HLA1','ANWAEVN','0','Y','ACFS','ACFSCC','ACFSCCCV','N','CEILING & FLOOR_INDOOR','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','DMZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','HTNC306HLA0',to_date('10-FEB-11','DD-MON-RR'),'ANWAEVN','HTNC306HLA0','ANWAEVN','0','Y','ACFS','ACFSCC','ACFSCCCV','N','CEILING & FLOOR_INDOOR','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','DMZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','HTNC306HLA1',to_date('08-FEB-11','DD-MON-RR'),'ANWAMAS','HTNC306HLA1','ANWAMAS','0','Y','ACFS','ACFSCC','ACFSCCCV','N','Cassette_I/D','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','DMZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','HTNC368DLA0',to_date('11-JUN-08','DD-MON-RR'),'ANWAEVN','HTNC368DLA0','ANWAEVN','5','Y','ACFS','ACFSCC','ACFSCCCV','N','CEILING & FLOOR_INDOOR','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','DMZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','HTNC368DLA1',to_date('06-OCT-08','DD-MON-RR'),'ANWAEVN','HTNC368DLA1','ANWAEVN','0','Y','ACFS','ACFSCC','ACFSCCCV','N','Cassette_I/D','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','DMZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','HTNC488DLA0',to_date('05-JAN-07','DD-MON-RR'),'ANWAEVN','HTNC488DLA0','ANWAEVN','5','Y','ACFS','ACFSCC','ACFSCCCV','N','CEILING CASSETTE (5HP)',null,'Y',to_date('16-NOV-12','DD-MON-RR'),'F','DMZ','EASV','EA','J','2',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','LTNC488DLA0',to_date('05-JAN-07','DD-MON-RR'),'ANWAEVN','HTNC488DLA0','CL01725','1','S','ACFS','ACFSCC','ACFSCCCV','N','Cassette_I/D_Inverter_H/P',null,'Y',to_date('16-NOV-12','DD-MON-RR'),'F','DMZ','EASV','EA','J','2',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','HTNC488DLA1',to_date('06-OCT-08','DD-MON-RR'),'ANWAEVN','HTNC488DLA1','ANWAEVN','0','Y','ACFS','ACFSCC','ACFSCCCV','N','Cassette_I/D','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','DMZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','HTUC186HLA1',to_date('11-JUN-08','DD-MON-RR'),'ANWAEVN','HTUC186HLA1','ANWAEVN','0','Y','ACFS','ACFSCC','ACFSCCCU','N','CEILING & FLOOR_OUTDOOR','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','DMZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','HTUC246HLA1',to_date('11-JUN-08','DD-MON-RR'),'ANWAEVN','HTUC246HLA1','ANWAEVN','0','Y','ACFS','ACFSCC','ACFSCCCU','N','CEILING & FLOOR_OUTDOOR','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','DMZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','HTUC306HLA0',to_date('10-FEB-11','DD-MON-RR'),'ANWAEVN','HTUC306HLA0','ANWAEVN','0','Y','ACFS','ACFSCC','ACFSCCCU','N','CEILING & FLOOR_OUTDOOR','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','DMZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','HTUC306HLA1',to_date('08-FEB-11','DD-MON-RR'),'ANWAMAS','HTUC306HLA1','ANWAMAS','0','Y','ACFS','ACFSCC','ACFSCCCU','N','Cassette_O/D','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','DMZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','HTUC368DLA0',to_date('11-JUN-08','DD-MON-RR'),'ANWAEVN','HTUC368DLA0','ANWAEVN','5','Y','ACFS','ACFSCC','ACFSCCCU','N','CEILING & FLOOR_OUTDOOR','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','DMZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','HTUC368DLA1',to_date('06-OCT-08','DD-MON-RR'),'ANWAEVN','HTUC368DLA1','ANWAEVN','5','Y','ACFS','ACFSCC','ACFSCCCU','N','Cassette_O/D','D','Y',to_date('14-JAN-13','DD-MON-RR'),'Q','DMZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','HTUC488DLA0',to_date('05-JAN-07','DD-MON-RR'),'ANWAEVN','HTUC488DLA0','ANWAEVN','5','Y','ACFS','ACFSCC','ACFSCCCU','N','CEILING CASSETTE (5HP)','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','DMZ','EASV','EA','S','2',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','LTUC488DLA0',to_date('05-JAN-07','DD-MON-RR'),'ANWAEVN','HTUC488DLA0','CL01726','1','S','ACFS','ACFSCC','ACFSCCCU','N','CEILING CASSETTE (5HP)',null,'Y',to_date('16-NOV-12','DD-MON-RR'),'F','DMZ','EASV','EA','J','2',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','HTUC488DLA1',to_date('06-OCT-08','DD-MON-RR'),'ANWAEVN','HTUC488DLA1','ANWAEVN','0','Y','ACFS','ACFSCC','ACFSCCCU','N','Cassette_O/D','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','DMZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','HV-C306KLA0',to_date('15-SEP-11','DD-MON-RR'),'ANWAEVN','HV-C306KLA0','ANWAEVN','0','Y','ACFS','ACFSCV','ACFSCVVJ','N','Convertible_Set','D','Y',to_date('16-NOV-12','DD-MON-RR'),'C','DMZ','EASV','ST','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','HV-C366LLA0',to_date('15-SEP-11','DD-MON-RR'),'ANWAEVN','HV-C366LLA0','ANWAEVN','0','Y','ACFS','ACFSCV','ACFSCVVJ','N','Convertible_Set','D','Y',to_date('16-NOV-12','DD-MON-RR'),'C','DMZ','EASV','ST','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','HV-C366WSB0',to_date('24-JUL-09','DD-MON-RR'),'DNWABML','HV-C366WSB0','DNWABML','0','Y','ACFS','ACFSCV','ACFSCVVJ','N','Ceiling & Floor_Set','D','Y',to_date('16-NOV-12','DD-MON-RR'),'C','DMZ','EASV','ST','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','HV-C488LLA0',to_date('31-MAY-11','DD-MON-RR'),'ANWAEVN','HV-C488LLA0','ANWAEVN','0','Y','ACFS','ACFSCV','ACFSCVVJ','N','Convertible_Set','D','Y',to_date('16-NOV-12','DD-MON-RR'),'C','DMZ','EASV','ST','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','HV-C488WSB0',to_date('24-JUL-09','DD-MON-RR'),'ANWABML','HV-C488WSB0','ANWABML','0','Y','ACFS','ACFSCV','ACFSCVVJ','N','Ceiling & Floor_Set','D','Y',to_date('16-NOV-12','DD-MON-RR'),'C','DMZ','EASV','ST','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','HV-C608WSB0',to_date('24-JUL-09','DD-MON-RR'),'ANWABML','HV-C608WSB0','ANWABML','0','Y','ACFS','ACFSCV','ACFSCVVJ','N','Ceiling & Floor_Set','D','Y',to_date('16-NOV-12','DD-MON-RR'),'C','DMZ','EASV','ST','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','HVNC186WSB1',to_date('11-JUN-09','DD-MON-RR'),'DNWAMAS','HVNC186WSB1','DNWAMAS','5','Y','ACFS','ACFSCV','ACFSCVVN','N','Ceiling & Floor_I/D','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','DMZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','HVNC306KLA0',to_date('15-SEP-11','DD-MON-RR'),'ANWAEVN','HVNC306KLA0','ANWAEVN','0','Y','ACFS','ACFSCV','ACFSCVVN','N','Convertible_I/D','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','DMZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','HVNC366LLA0',to_date('15-SEP-11','DD-MON-RR'),'ANWAEVN','HVNC366LLA0','ANWAEVN','0','Y','ACFS','ACFSCV','ACFSCVVN','N','Convertible_I/D','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','DMZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','HVNC366WSB0',to_date('24-JUL-09','DD-MON-RR'),'DNWABML','HVNC366WSB0','DNWABML','5','Y','ACFS','ACFSCV','ACFSCVVN','N','Ceiling & Floor_I/D','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','DMZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','HVNC366WSB1',to_date('17-JUN-10','DD-MON-RR'),'DNWAEVN','HVNC366WSB1','DNWAEVN','0','Y','ACFS','ACFSCV','ACFSCVVN','N','Ceiling & Floor_I/D','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','DMZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','HVNC488LLA0',to_date('31-MAY-11','DD-MON-RR'),'ANWAEVN','HVNC488LLA0','ANWAEVN','5','Y','ACFS','ACFSCV','ACFSCVVN','N','Convertible_I/D','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','DMZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','HVNC488WSB0',to_date('24-JUL-09','DD-MON-RR'),'ANWABML','HVNC488WSB0','ANWABML','0','Y','ACFS','ACFSCV','ACFSCVVN','N','Ceiling & Floor_I/D','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','DMZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','HVNC488WSB1',to_date('10-SEP-10','DD-MON-RR'),'DNWAEVN','HVNC488WSB1','DNWAEVN','5','Y','ACFS','ACFSCV','ACFSCVVN','N','Ceiling & Floor_I/D','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','DMZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','HVNC608WSB0',to_date('24-JUL-09','DD-MON-RR'),'ANWABML','HVNC608WSB0','ANWABML','0','Y','ACFS','ACFSCV','ACFSCVVN','N','Ceiling & Floor_I/D','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','DMZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','HVUC186WSB1',to_date('11-JUN-09','DD-MON-RR'),'DNWAMAS','HVUC186WSB1','DNWAMAS','5','Y','ACFS','ACFSCV','ACFSCVVU','N','Ceiling & Floor_O/D','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','DMZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','HVUC306KLA0',to_date('15-SEP-11','DD-MON-RR'),'ANWAEVN','HVUC306KLA0','ANWAEVN','0','Y','ACFS','ACFSCV','ACFSCVVU','N','Convertible_O/D','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','DMZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','HVUC366LLA0',to_date('15-SEP-11','DD-MON-RR'),'ANWAEVN','HVUC366LLA0','ANWAEVN','0','Y','ACFS','ACFSCV','ACFSCVVU','N','Convertible_O/D','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','DMZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','HVUC366WSB0',to_date('24-JUL-09','DD-MON-RR'),'DNWABML','HVUC366WSB0','DNWABML','5','Y','ACFS','ACFSCV','ACFSCVVU','N','Ceiling & Floor_O/D','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','DMZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','HVUC366WSB1',to_date('17-JUN-10','DD-MON-RR'),'DNWAEVN','HVUC366WSB1','DNWAEVN','0','Y','ACFS','ACFSCV','ACFSCVVU','N','Ceiling & Floor_O/D','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','DMZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','HVUC488LLA0',to_date('31-MAY-11','DD-MON-RR'),'ANWAEVN','HVUC488LLA0','ANWAEVN','5','Y','ACFS','ACFSCV','ACFSCVVU','N','Convertible_O/D','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','DMZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','HVUC488WSB0',to_date('24-JUL-09','DD-MON-RR'),'ANWABML','HVUC488WSB0','ANWABML','0','Y','ACFS','ACFSCV','ACFSCVVU','N','Ceiling & Floor_O/D','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','DMZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','HVUC488WSB1',to_date('10-SEP-10','DD-MON-RR'),'DNWAEVN','HVUC488WSB1','DNWAEVN','5','Y','ACFS','ACFSCV','ACFSCVVU','N','Ceiling & Floor_O/D','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','DMZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','HVUC608WSB0',to_date('24-JUL-09','DD-MON-RR'),'ANWABML','HVUC608WSB0','ANWABML','5','Y','ACFS','ACFSCV','ACFSCVVU','N','Ceiling & Floor_O/D','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','DMZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('TV','HW300G',to_date('21-APR-11','DD-MON-RR'),'ATV','HW300G','ATV','0','S','TVPR','TVPRME','TVPRMENW','N','PJTR MOBILE LED WXGA','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','GLZ','EASV','EA','S','2',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('TV','HW301G',to_date('09-JUN-11','DD-MON-RR'),'ATVZ','HW301G','ATVZ','0','S','TVPR','TVPRME','TVPRMENW','N','PJTR MOBILE LED WXGA','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','GLZ','EASV','EA','S','2',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('TV','HX300G',to_date('20-JUL-11','DD-MON-RR'),'AMA','HX300G','AMA','0','S','TVPR','TVPRME','TVPRMENX','N','LED XGA PJTR','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','GLZ','EASV','EA','S','2',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('TV','HX301G',to_date('14-APR-11','DD-MON-RR'),'AEU','HX301G','AEU','0','S','TVPR','TVPRME','TVPRMENX','N','PJTR MOBILE LED XGA','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','GLZ','EASV','EA','S','2',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AV','HX906TX',to_date('19-MAY-11','DD-MON-RR'),'BVNMLL','HX906TX','BVNMLL','0','S','AVAH','AVAHBH','AVAHBHBS','N','BD-P HTS Basic','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','PNZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AV','HX906TX-MM',to_date('19-MAY-11','DD-MON-RR'),'BVNMLL','HX906TX','BVNMLL','0','N','AVAH','AVAHBH','AVAHBHBS','N','BD-P HTS Basic','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','PNZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AV','HX995TZ',to_date('06-OCT-10','DD-MON-RR'),'BVNMLLK','HX995TZ','BVNMLLK','5','S','AVAH','AVAHBH','AVAHBHBS','N','3D BD-P HTS Basic','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','PNZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AV','HX995TZ-FD',to_date('06-OCT-10','DD-MON-RR'),'BVNMLLK','HX995TZ','BVNMLLK','0','N','AVAH','AVAHBH','AVAHBHBS','N','3D BD-P HTS Basic','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','PNZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AV','HX995TZW-FD',to_date('27-AUG-10','DD-MON-RR'),'BVNMLLK','HX995TZW-FD','BVNMLLK','0','Y','AVAH','AVAHBH','AVAHBHBS','N','BD-P HTS Basic','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','PNZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AV','HX996TS',to_date('09-FEB-11','DD-MON-RR'),'BVNMLLK','HX996TS','BVNMLLK','5','S','AVAH','AVAHBH','AVAHBHBS','N','BD-P HTS Basic, 3D Sound HTS, Asian','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','PNZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AV','HX996TS-MM',to_date('09-FEB-11','DD-MON-RR'),'BVNMLLK','HX996TS','BVNMLLK','0','N','AVAH','AVAHBH','AVAHBHBS','N','BD-P HTS Basic, 3D Sound HTS, Asian','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','PNZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('CP','I-PART',to_date('28-MAY-09','DD-MON-RR'),'KCCZ','I-PART','KCCZ','0','Y','CPRF','CPRFPZ','CPRFPZIA','N','I-Part','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','CCZ','EASV','EA','S','1',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('HT','IDS-10W',to_date('17-JUN-11','DD-MON-RR'),'AL','IDS-10W','AL','0','Y','HTTA','HTTAEA','HTTAEANN','N','Commercial_TV etc.(Except for PDP TV)','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','GLZ','EASV','EA','S','2',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('TV','IND-100SN',to_date('25-JAN-08','DD-MON-RR'),'*******','IND-100SN','A','5','Y','TVAC','TVACPR','TVACPRNN','N','Projector Accessory','G','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','ZZZ','EASV','EA','S','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('MN','IPS206T-PN',to_date('19-NOV-10','DD-MON-RR'),'ATVZ','IPS206T-PN','ATVZ','1','S','MNLC','MNLC20','MNLC20NW','N','LCD Monitor 20 (WIDE)','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','GMZ','EASV','EA','S','1',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('MN','IPS224T-PN',to_date('03-FEB-12','DD-MON-RR'),'ATVZ','IPS224T-PN','ATVZ','0','S','MNLC','MNLC22','MNLC22NW','Y','LCD Monitor 22 (WIDE)','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','GMZ','EASV','EA','S','2',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('MN','IPS224V-PN',to_date('03-FEB-12','DD-MON-RR'),'ATVZ','IPS224V-PN','ATVZ','0','S','MNLC','MNLC22','MNLC22NW','N','LCD Monitor 22 (WIDE)','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','GMZ','EASV','EA','S','2',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('MN','IPS225P-BN',to_date('08-MAR-11','DD-MON-RR'),'ATVZ','IPS225P-BN','ATVZ','0','S','MNLC','MNLC22','MNLC22NW','Y','LCD Monitor 22 (WIDE)','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','GMZ','EASV','EA','S','2',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('MN','IPS225T-BN',to_date('08-MAR-11','DD-MON-RR'),'ATVZ','IPS225T-BN','ATVZ','0','S','MNLC','MNLC22','MNLC22NW','N','LCD Monitor 22 (WIDE)','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','GMZ','EASV','EA','S','2',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('MN','IPS225V-BN',to_date('08-MAR-11','DD-MON-RR'),'ATVZ','IPS225V-BN','ATVZ','0','S','MNLC','MNLC22','MNLC22NW','N','LCD Monitor 22 (WIDE)','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','GMZ','EASV','EA','S','2',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('MN','IPS226V-PN',to_date('19-NOV-10','DD-MON-RR'),'ATVZ','IPS226V-PN','ATVZ','5','S','MNLC','MNLC22','MNLC22NW','N','LCD Monitor 22 (WIDE)','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','GMZ','EASV','EA','S','2',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('MN','IPS231P-BN',to_date('19-NOV-10','DD-MON-RR'),'ATVZ','IPS231P-BN','ATVZ','0','S','MNLC','MNLC23','MNLC23NW','Y','LCD Monitor 23 (WIDE)','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','GMZ','EASV','EA','S','2',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('MN','IPS234T-PN',to_date('03-FEB-12','DD-MON-RR'),'ATVZ','IPS234T-PN','ATVZ','0','S','MNLC','MNLC23','MNLC23NW','Y','LCD Monitor 23 (WIDE)','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','GMZ','EASV','EA','S','2',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('MN','IPS234V-PN',to_date('03-FEB-12','DD-MON-RR'),'ATVZ','IPS234V-PN','ATVZ','0','S','MNLC','MNLC23','MNLC23NW','N','LCD Monitor 23 (WIDE)','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','GMZ','EASV','EA','S','2',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('MN','IPS235P-BN',to_date('08-MAR-11','DD-MON-RR'),'ATVZ','IPS235P-BN','ATVZ','0','S','MNLC','MNLC23','MNLC23NW','Y','LCD Monitor 23 (WIDE)','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','GMZ','EASV','EA','S','2',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('MN','IPS235T-BN',to_date('08-MAR-11','DD-MON-RR'),'ATVZ','IPS235T-BN','ATVZ','0','S','MNLC','MNLC23','MNLC23NW','Y','LCD Monitor 23 (WIDE)','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','GMZ','EASV','EA','S','2',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('MN','IPS235V-BN',to_date('08-MAR-11','DD-MON-RR'),'ATVZ','IPS235V-BN','ATVZ','5','S','MNLC','MNLC23','MNLC23NW','N','LCD Monitor 23 (WIDE)','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','GMZ','EASV','EA','S','2',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('MN','IPS236V-PN',to_date('24-JAN-11','DD-MON-RR'),'ATC','IPS236V-PN','ATC','0','S','MNLC','MNLC23','MNLC23NW','N','LCD Monitor 23 (WIDE)','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','GMZ','EASV','EA','S','2',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('MN','IPS236V-PNX',to_date('19-NOV-10','DD-MON-RR'),'ATVLFSN','IPS236V-PN','ATVZ','0','N','MNLC','MNLC23','MNLC23NW','Y','LCD Monitor 23 (WIDE)','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','GMZ','EASV','EA','S','2',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('MN','IPS237L-BN',to_date('19-OCT-12','DD-MON-RR'),'ATVZ','IPS237L-BN','ATVZ','0','S','MNLC','MNLC23','MNLC23NW','Y','LCD Monitor 23 (WIDE)','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','GMZ','EASV','EA','S','2',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('MN','IPS265V-BN',to_date('04-MAR-11','DD-MON-RR'),'ATVZ','IPS265V-BN','ATVZ','0','S','MNLC','MNLC26','MNLC26NW','Y','LCD Monitor 26 (WIDE)','D','Y',to_date('16-NOV-12','DD-MON-RR'),'Q','GMZ','EASV','EA','S','2',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('RF','IRON',to_date('21-SEP-10','DD-MON-RR'),'KMAI','IRON','KMAI','0','Y','RFPZ','RFPZPZ','RFPZPZPP','N','Electric iron','G','Y',to_date('16-NOV-12','DD-MON-RR'),'H','ZZZ','EASV','EA','S','2',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('TV','ISAKNOX',to_date('11-OCT-12','DD-MON-RR'),'KMAI','ISAKNOX','KMAI','0','Y','TVLE','TVLE42','TVLE42NF','N','BO MY PHAM ISAKNOX','G','Y',to_date('16-NOV-12','DD-MON-RR'),'H','ZZZ','EASV','EA','S','2',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('TV','ISAKNOX1',to_date('17-OCT-12','DD-MON-RR'),'KMAI','ISAKNOX1','KMAI','0','Y','TVAC','TVACEA','TVACEANN','N','Bo my pham Isaknox1','G','Y',to_date('16-NOV-12','DD-MON-RR'),'H','ZZZ','EASV','EA','S','2',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','J-C09E',to_date('08-MAY-08','DD-MON-RR'),'AMBBEV1','J-C09E','AMBBEV1','0','Y','ACSR','ACSRNR','ACSRNRBJ','N','Single Split Wall_Set','D','Y',to_date('16-NOV-12','DD-MON-RR'),'C','DGZ','EASV','ST','S','2',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','HS-C0964EA3',to_date('09-JAN-08','DD-MON-RR'),'AMBBEVN','J-C09E','AMBBEVN','0','N','ACSR','ACSRNR','ACSRNRBJ','N','Single Split Wall_Set',null,'Y',to_date('16-NOV-12','DD-MON-RR'),'C','DGZ','EASV','ST','J','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','J-C09S',to_date('02-APR-09','DD-MON-RR'),'AMBAEVN','J-C09S','AMBAEVN','0','S','ACSR','ACSRNR','ACSRNRBJ','Y','Single Split Wall_Set','D','Y',to_date('16-NOV-12','DD-MON-RR'),'C','DGZ','EASV','ST','S','2',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','VS-C096YTA0',to_date('15-JUL-08','DD-MON-RR'),'AMBBEVN','J-C09T','AMBBEVN','0','N','ACSR','ACSRNR','ACSRNRBJ','N','Single Split Wall_Set',null,'Y',to_date('16-NOV-12','DD-MON-RR'),'C','DGZ','EASV','ST','J','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','TS-C096YTA0',to_date('04-AUG-08','DD-MON-RR'),'AMBBEVN','J-C09T','AMBBEVN','0','N','ACSR','ACSRNR','ACSRNRBJ','Y','Single Split Wall_Set',null,'Y',to_date('16-NOV-12','DD-MON-RR'),'C','DGZ','EASV','ST','J','0',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','J-C09T1',to_date('04-AUG-10','DD-MON-RR'),'AMBBEVN','J-C09T1','AMBBEVN','0','S','ACSR','ACSRNR','ACSRNRBJ','N','Single Split Wall_Set',null,'Y',to_date('16-NOV-12','DD-MON-RR'),'C','DGZ','EASV','ST','J','2',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into MODEL_CAT (PROD_L1,MODEL,CREATE_DATE,SUFFIX,MP_MODEL,MP_SUFFIX,ACTIVE_CODE,SALE_FLAG,PROD_L2,PROD_L3,PROD_L4,TENTATIVE_FLAG,MODEL_SPEC,PUR_TYPE,ENABLE_FLAG,LAST_UPDATE_DATE,UNIT,AU_CODE,AF_CODE,EOM,PROD_TYPE,MKT,IF_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('AC','TS-C096YTA1',to_date('04-AUG-10','DD-MON-RR'),'AMBBEVN','J-C09T1','AMBBEVN','0','N','ACSR','ACSRNR','ACSRNRBJ','N','Single Split Wall_Set',null,'Y',to_date('16-NOV-12','DD-MON-RR'),'C','DGZ','EASV','ST','J','2',to_date('29-MAY-13','DD-MON-RR'),'Y',to_date('04-JUL-14','DD-MON-RR'));
